﻿var readyJSON = [
{ accountcode: "PL03010000", exchangerate: true, description: "Global Sales", datarow: true, index: 1, internalsales: { add: false, entity: 'All', convertT: "RBNW", fields: ['BA_SI03010201', 'BA_SI03030201', 'BA_SI03040101', 'BA_SI03050201', 'BA_SI03060201'] }
},
{ emptyrow: true, description: "" },
{ accountcode: "PL03010101-1", unit: "#T#", exchangerate: false,
    internalsales: {
        entity: 'All',
        convertT: "RBNW",
        fields: ['Qty_SI03010201'],
        exchangerate: false,
        add: false
    }, convertT: "RBNW", description: "Tonnages (Head Products Manufactured)", datarow: true, index: 0
},
{ accountcode: "PL03010101-2", unit: "#T#", exchangerate: false, description: "Tonnages (First Products Manufactured)", convertT: "RBNW", datarow: true, index: 0 },
{ accountcode: "PL03010102", description: "Sales (All manufactured products)", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03010102-1", "PL03010102-2"],
        equ: "+"
    }
}]
},
{ accountcode: "PL03010102-1", exchangerate: true, 
internalsales: {
    entity: 'All',
    fields: ['BA_SI03010201'],
    add: false
}, description: "Sales (Head Products products)", datarow: true, index: 0
},
{ accountcode: "PL03010102-2", exchangerate: true, description: "Sales (First Products products)", datarow: true, index: 0 },
{ accountcode: "PL03010103", exchangerate: true, description: "SBEW Cost", datarow: true, index: 0 },
{ accountcode: "PL03010103-1", exchangerate: true, description: "hidden field", hide: true, datarow: true, index: 0 },
{ accountcode: "PL03010104", exchangerate: true, description: "VC - Manufactured products", datarow: true, index: 0, internalsales: {
    entity: 'All',
    fields: ['BA_SI03010201'],
    add: true
}
},
{ accountcode: "PL03010105", description: "VM - Manufactured products", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03010102", "PL03010103", "PL03010104"],
        equ: "+"
    }
}]
},
{ accountcode: "PL03010106", description: "VM / Sales", datarow: true, index: 3, exchangerate: false, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03010105", "PL03010102"], addition: "{0}*100",
        equ: "/"
    }
}], digits: 1, unit: "%"
},

{ accountcode: "Control", description: "PL03010103=SB0301000", controlrow: true, Process: [
 { Field: "All",
     Exp: {
         mode: "search",
         fields: ["PL03010103", "Refrence&R_Budget_SBEW&SB0301000"],
         equ: "-"
     } 
 }]
},
{ emptyrow: true, description: "" },
{ accountcode: "PL03010201-1", unit: "#T#", exchangerate: false, convertT: "RBNW", description: "Tonnages  (Head Products Traded)", style: "green_loading", datarow: true, index: 0 },
{ accountcode: "PL03010201-2", unit: "#T#", exchangerate: false, convertT: "RBNW", description: "Tonnages (First Products Traded)", style: "green_loading", datarow: true, index: 0 },
{ accountcode: "PL03010202", description: "Sales  (All Traded Products)", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL030102020-1", "PL030102020-2"],
        equ: "+"
    }
}]
},
{ accountcode: "PL030102020-1", exchangerate: true, description: "Sales (Head Products Traded)", style: "green_loading", datarow: true, index: 0 },
{ accountcode: "PL030102020-2", exchangerate: true, description: "Sales (First Products Traded)", style: "green_loading", datarow: true, index: 0 },
{ accountcode: "PL03010203", exchangerate: true, description: "SBEW Cost", style: "green_loading", datarow: true, index: 0 },
{ accountcode: "PL03010204", exchangerate: true, description: "VC - Traded Products", datarow: true, index: 0 },
{ accountcode: "PL03010205", description: "VM - Traded Products", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03010202", "PL03010203", "PL03010204"],
        equ: "+"
    }
}]
},
{ emptyrow: true, description: "" },
{ accountcode: "PL03010300", description: "Sales + VM-Traded Products", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03010102", "PL03010205"],
        equ: "+"
    }
}]
},
{ emptyrow: true, description: "" },
{ accountcode: "PL03010400", exchangerate: true, internalsales: { entity: 'All', fields: ['BA_SI03040101'] }, description: "Sales - Commission income", datarow: true, index: 0 },
{ emptyrow: true, description: "" },
{ accountcode: "PL03010500", exchangerate: true, internalsales: { entity: 'All', fields: ['BA_SI03030201'] }, description: "Sales - Services", datarow: true, index: 0 },

{ accountcode: "PL03010600", description: "VM-Total", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03010105", "PL03010205", "PL03010400", "PL03010500"],
        equ: "+"
    }
}], ProcessTODO: "from Flash input-Sales Commission&Service-SV03030100"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL03020101", exchangerate: true, description: "Fixed Operating Costs - Net", datarow: true, index: 0,
    internalsales: {
        entity: 'All',
        fields: ['BA_SI03040101'],
        add: true
    }
},
{ accountcode: "PL03020102", exchangerate: true, description: "Fixed Operating Costs - Gross Cost", datarow: true, index: 0,
    internalsales: {
        entity: 'All',
        fields: ['BA_SI03040101'],
        add: true
    }
},
{ accountcode: "PL03020103", description: "Fixed Operating Costs - Stock movement", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03020101", "PL03020102"],
        equ: "-"
    }
}]
},
{ emptyrow: true, description: "" },
{ accountcode: "PL03030101", description: "Commercial Contribution (CC)", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03010105", "PL03010205", "PL03020101", "PL03010400", "PL03010500"],
        equ: "+"
    }
}], ProcessTODO: "=PL03010105+PL03010205+PL03020101"
},
{ accountcode: "PL03030102", description: "CC / (Sales + VM Traded Products)", datarow: true, index: 0, exchangerate: false, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03030101", "PL03010300"], addition: "{0}*100",
        equ: "/"
    }
}], ProcessTODO: "=PL03030101/PL03010300", digits: 1, unit: "%"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL03020201", exchangerate: true, description: "Operating depreciation - Net", datarow: true, index: 0 },
{ accountcode: "PL03020202", exchangerate: true, description: "Operating depreciation - Gross", datarow: true, index: 0 },
{ accountcode: "PL03020203", description: "Operating depreciation - Stock movement", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03020201", "PL03020202"],
        equ: "-"
    }
}], ProcessTODO: "=PL03020201-PL03020202"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL03040101", description: "Commercial Margin (CM)", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03030101", "PL03020201"],
        equ: "+"
    }
}]
},
{ accountcode: "PL03040102", description: "CM / (Sales + VM Traded Products)", datarow: true, index: 0, exchangerate: false, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03040101", "PL03010300"], addition: "{0}*100",
        equ: "/"
    }
}], ProcessTODO: "=PL03040101/PL03010300", digits: 1, unit: "%"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL03020104", exchangerate: true, description: "Admin. Excl. Depreciation - Net", datarow: true, index: 0,
    internalsales: {
        entity: 'All',
        fields: ['BA_SI03030201'],
        add: true
    }
},
{ accountcode: "PL03020105", exchangerate: true, description: "Admin. Excl. Depreciation - Gross", datarow: true, index: 0,
    internalsales: {
        entity: 'All',
        fields: ['BA_SI03030201'],
        add: true
    }
},
{ accountcode: "PL03020106", description: "Admin. Excl. Depreciation - Cycle movement", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03020104", "PL03020105"],
        equ: "-"
    }
}], ProcessTODO: "Calculate=PL03020105-PL03020104"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL03020107", exchangerate: true, description: "R&D Excl. Depreciation - Net", datarow: true, index: 0 },
{ accountcode: "PL03020108", exchangerate: true, description: "R&D. Excl. Depreciation - Gross", datarow: true, index: 0 },
{ accountcode: "PL03020109", description: "R&D Excl. Depreciation - Cycle movement", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03020107", "PL03020108"],
        equ: "-"
    }
}]
},
{ emptyrow: true, description: "" },
{ accountcode: "PL03050101", description: "Economic EBITDA", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03030101", "PL03020104", "PL03020107"],
        equ: "+"
    }
}]
},
{ accountcode: "PL03050102", description: "Economic EBITDA  / (Sales + VM Traded Products) (%)", datarow: true, index: 0, exchangerate: false, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03050101", "PL03010300"], addition: "{0}*100",
        equ: "/"
    }
}], ProcessTODO: "Calculate:=PL03050101 / PL03010300", digits: 1, unit: "%"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL03020204", exchangerate: true, description: "Depreciation - Admin (gross)", datarow: true, index: 0 },
{ accountcode: "PL03020205", exchangerate: true, description: "Depreciation - R&D (gross)", datarow: true, index: 0 },
{ emptyrow: true, description: "" },
{ accountcode: "PL03020206", description: "Depreciation ALL - Net", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03020201", "PL03020204", "PL03020205"],
        equ: "+"
    }
}], ProcessTODO: "=PL03020201+PL03020204+PL03020205"
},
{ accountcode: "PL03020207", description: "Depreciation ALL - Gross", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03020202", "PL03020204", "PL03020205"],
        equ: "+"
    }
}], ProcessTODO: "calculate:='Operating depreciation - Gross'+'Depreciation - Admin'+'Depreciation - R&D'"
},
{ accountcode: "PL03020208", description: "Depreciation ALL - Stock movement", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03020206", "PL03020207"],
        equ: "-"
    }
}], ProcessTODO: "calculate:=PL03020207-PL03020206"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL03060101", description: "Operating profit (OP)", datarow: true, index: 0, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03050101", "PL03020206"],
        equ: "+"
    }
}], ProcessTODO: "calculate:=PL03050101+PL03020206"
},
{ accountcode: "PL03060102", description: "OP / (Sales + VM Traded Products) (%)", datarow: true, index: 0, exchangerate: false, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03060101", "PL03010300"], addition: "{0}*100",
        equ: "/"
    }
}], ProcessTODO: "calculate:=PL03060101 / PL03010300", digits: 1, unit: "%"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL03020500", description: "Transitions gains & charges", datarow: true, index: 0, bold: true, Process: [{
    Field: "All",
    Exp: {
        mode: "to",
        start: "PL03020501",
        end: "PL03020506",
        equ: "+"
    }
}], ProcessTODO: "Sum"
},
{ accountcode: "PL03020501", exchangerate: true, description: "Sales -Others", datarow: true, index: 0 },
{ accountcode: "PL03020502", exchangerate: true, description: "Cost - Other sales", datarow: true, index: 0 },
{ accountcode: "PL03020503", exchangerate: true, description: "Resin", datarow: true, index: 0 },
{ accountcode: "PL03020504", exchangerate: true, description: "Income tax adjustments", datarow: true, index: 0 },
{ accountcode: "PL03020505", exchangerate: true, description: "FI-CO variance (depreciation gap)", datarow: true, index: 0 },
{ accountcode: "PL03020506", exchangerate: true, description: "FI-CO Other variance", datarow: true, index: 0 },
{ emptyrow: true, description: "" },
{ accountcode: "PL03020300", description: "Other Operating Gains & Charges", datarow: true, index: 0, bold: true, Process: [{
    Field: "All",
    Exp: {
        mode: "to",
        start: "PL03020301",
        end: "PL03020309",
        equ: "+"
    }
}]
},
{ accountcode: "PL03020301", exchangerate: true, description: "Sales - Disposal of FA", datarow: true, index: 0 },
{ accountcode: "PL03020302", exchangerate: true, description: "Cost of FA disposal-Gross book value", datarow: true, index: 0 },
{ accountcode: "PL03020310", exchangerate: true, description: "Cost of FA disposal- Reversal of cumulative depreciation", datarow: true, index: 0 },
{ accountcode: "PL03020303", exchangerate: true, description: "Sales - Scrap", datarow: true, index: 0 },
{ accountcode: "PL03020304", exchangerate: true, description: "Cost - Scrap", datarow: true, index: 0 },
{ accountcode: "PL03020305", exchangerate: true, description: "Impairement in Fixed Assets & Goodwill", datarow: true, index: 0 },
{ accountcode: "PL03020306", exchangerate: true, description: "Restructuration & Litigation", datarow: true, index: 0 },
{ accountcode: "PL03020307", exchangerate: true, description: "Hedging (floating gain &loss)", datarow: true, index: 0 },
{ accountcode: "PL03020308", exchangerate: true, description: "Other Provision", datarow: true, index: 0 },
{ accountcode: "PL03020309", exchangerate: true, description: "Other operating Expenses & Income", datarow: true, index: 0 },


{ emptyrow: true, description: "" },
{ accountcode: "PL03070101", description: "Operating Income", datarow: true, index: 0, bold: true, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03060101", "PL03020500", "PL03020300"],
        equ: "+"
    }
}], ProcessTODO: "=PL03060101+PL03020500+PL03020300"
},
{ accountcode: "PL03070102", description: "Operating Income/ (sales + VM Traded Products) %", datarow: true, index: 0, exchangerate: false, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03070101", "PL03010300"], addition: "{0}*100",
        equ: "/"
    }
}], ProcessTODO: "=PL03070101/  PL03010300", digits: 1, unit: "%"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL03020400", description: "Financial", datarow: true, index: 0, bold: true, Process: [{
    Field: "All",
    Exp: {
        mode: "to",
        start: "PL03020401",
        end: "PL03020406",
        equ: "+"
    }
}], ProcessTODO: "sum PL03020401 to PL03020406"
},
{ accountcode: "PL03020401", exchangerate: true,
    internalsales: {
        entity: 'All',
        fields: ['BA_SI03060201'],
        add: true
    }, description: "Interest expense", datarow: true, index: 0
},
{ accountcode: "PL03020402", exchangerate: true, 
internalsales: {
    entity: 'All',
    fields: ['BA_SI03060201'],
    add: false
}, description: "Interest income", datarow: true, index: 0
},
{ accountcode: "PL03020403", exchangerate: true, description: "Actualized FX gain/loss - cash & debt", datarow: true, index: 0 },
{ accountcode: "PL03020404", exchangerate: true, description: "Actualized FX gain/loss - excluding cash & debt", datarow: true, index: 0 },
{ accountcode: "PL03020405", exchangerate: true, description: "Floating FX gain/loss - cash & debt", datarow: true, index: 0 },
{ accountcode: "PL03020406", exchangerate: true, description: "Floating FX gain/loss - excluding cash & debt", datarow: true, index: 0 },
{ emptyrow: true, description: "" },
{ accountcode: "PL03020600", exchangerate: true, description: "Corporate income taxes", datarow: true, index: 0, bold: true },
{ emptyrow: true, description: "" },
{ accountcode: "PL03080101", description: "Net Income", datarow: true, index: 0, bold: true, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03070101", "PL03020400", "PL03020600"],
        equ: "+"
    }
}], ProcessTODO: "=PL03070101+PL03020400+PL03020600"
},
{ accountcode: "PL03080102", description: "Net Income / (Sales + VM Traded Products) (%)", datarow: true, index: 0, exchangerate: false, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03080101", "PL03010300"], addition: "{0}*100",
        equ: "/"
    }
}], ProcessTODO: "=PL03080101 /PL03010300", digits: 1, unit: "%"
},
{ emptyrow: true, description: "" },
{ accountcode: "PL03090101", description: "Net Income Before Amort. & Depreciation", datarow: true, index: 0, bold: true, Process: [{
    Field: "All",
    Exp: {
        mode: "search",
        fields: ["PL03080101", "PL03020206", "PL03020505", "PL03020305", "PL03020503"],
        equ: "-"
    }
}]
},
{ emptyrow: true, description: "" }
];
